Full Load

This tab is available for tasks defined with the IBM DB2 for z/OS and IBM DB2 for iSeries source endpoints only.

Select the Eliminate creation of duplicate records on full load option if you need to prevent duplicate records from being replicated during Full Load. You can either set the option at task level or per table.

Note that selecting this option could impact performance as Replicate instructs the source database to return the table records by Primary Key order and then removes any duplicate records.

To prevent creation of duplicate records per table:

1. Select the desired table and then open the Table Settings window as described in Table Settings.
2. Select the Full Load tab and click the Change to Table Policy button.
3. Select the Prevent creation of duplicate records on the target check box.

For information on preventing creation of duplicate records at task level, see Full Load Settings.